Creating the User Credentials

Create the following cloud credentials using the Auth Token created earlier to access the swiftstore to import the database dump.

create_credential: Stores the object store credentials in your Autonomous Transaction Processing schema.

Execute the below procedure from admin schema to create the credentials.

Procedure to Create Credentials
Procedure 
begin
DBMS_CLOUD.create_credential (
credential_name => '<<Credential Name>>',
username => '<<Username>>',
password => '<<Password>>'
) ;
end;
/

Execute the below 'impdp' from the command line to import the OIPA and IVS database dumps to an ATP instance.

OIPA Schema
impdp 
 
impdp admin/<<password>>@<<TNS Name>> directory=data_pump_dir 
credential=<<Credential Name>> dumpfile=<<Dumpfile location from the swiftstore >> 
partition_options=merge transform=segment_attributes:n transform=dwcs_cvt_iots:y 
transform=constraint_use_default_index:y exclude=index, cluster, indextype, 
materialized_view, materialized_view_log, materialized_zonemap, 
db_link remap_schema=<<Source Schema>>:<<Target Schema>>remap_tablespace=USERS:DATA

 

 

IVS Schema
impdp 
 
impdp admin/<<password>>@<<TNS Name>> directory=data_pump_dir 
credential=<<Credential Name>> dumpfile=<<Dumpfile location from the swiftstore >> 
partition_options=merge transform=segment_attributes:n transform=dwcs_cvt_iots:y 
transform=constraint_use_default_index:y exclude=index, cluster, indextype, 
materialized_view, materialized_view_log, materialized_zonemap, 
db_link remap_schema=<<Source Schema>>:<<Target Schema>>remap_tablespace=USERS:DATA